Bag Equivalence of Bounded Symmetry-Degree Conjunctive Queries with Inequalities
نویسندگان
چکیده
We consider the problem of checking equivalence of conjunctive queries with inequalities under bag (multiset) semantics. The problem is known to be decidable in pspace and as hard as graph isomorphism, but its exact complexity remains open. We introduce a natural restriction based on what we call the symmetry degree of queries, and show that when the symmetry degree is bounded by a fixed polynomial in the size of the query, the equivalence problem is in Πp 2 . We also show that for asymmetric queries (those of symmetry degree 1), checking bag-equivalence is polynomial-time Turing equivalent to the graph automorphism problem. These results can be interpreted as first steps in a more general program of finding “islands of tractability” for testing equivalence of conjunctive queries with inequalities under bag (rather than set) semantics.
منابع مشابه
Combined-Semantics Equivalence Is Decidable for a Practical Class of Conjunctive Queries
The problems of query containment and equivalence arefundamental problems in the context of query processingand optimization. In their classic work [2] published in1977, Chandra and Merlin solved the two problems for the language of conjunctive queries (CQ queries) on relationaldata, under the “set-semantics” assumption for query evalu-ation. Alternative semantics, called ba...
متن کاملEquivalence and Minimization of Conjunctive Queries
The problems of query containment, equivalence, and minimization are fundamental problems in the context of query processing and optimization. In their classic work [2] published in 1977, Chandra and Merlin solved the three problems for the language of conjunctive queries (CQ queries) on relational data, under the “set-semantics” assumption for query evaluation. While the results of [2] have be...
متن کاملDwq : Esprit Long Term Research Project, No 22469 Deciding Equivalences among Aggregate Queries Deciding Equivalences among Aggregate Queries
Equivalence of aggregate queries is investigated for the class of conjunctive queries with comparisons and the aggregate operators min, max, count, count-distinct, and sum. Essentially, this class contains all unnested SQL queries with the above aggregate operators, with a WHERE clause consisting of a conjunction of comparisons, and without a HAVING clause. The comparisons can be interpreted ov...
متن کاملA The Fine Classification of Conjunctive Queries and Parameterized Logarithmic Space
at Wien We perform a fundamental investigation of the complexity of conjunctive query evaluation from the perspective of parameterized complexity. We classify sets of boolean conjunctive queries according to the complexity of this problem. Previous work showed that a set of conjunctive queries is fixed-parameter tractable precisely when the set is equivalent to a set of queries having bounded t...
متن کاملDesigning Views to Optimize Real Queries
This paper considers the following problem: given a query workload, a database, and a set of constraints, design a set of views that give equivalent rewritings of the workload queries and globally minimize the evaluation costs of the workload on the database under the constraints. We refer to this problem as “view design for query performance,” or “view design” for short; sets of views that sat...
متن کامل